﻿using System;
using System.Linq;
using System.Text;
using Model.Core;
using SIE.SCADA.SqlSugar;

namespace Models
{
    ///<summary>
    ///SCE的派工单信息
    ///</summary>
    [SugarTable("scada_product_info")]
    public partial class scada_product_info
    {
        public scada_product_info()
        {


        }
           
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int id { get; set; }

        /// <summary>
        /// Desc:SN序列号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string serial_number { get; set; }

        /// <summary>
        /// Desc:派工单
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string disidno { get; set; }

        /// <summary>
        /// Desc:Mbom版本号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string mbom { get; set; }

        /// <summary>
        /// Desc:产线编码
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string workbin { get; set; }

        /// <summary>
        /// Desc:产线名称
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string workbinname { get; set; }

        /// <summary>
        /// Desc:物料编号(产品物料号)
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string matid { get; set; }



        public string matid_old { get; set; }

        /// <summary>
        /// Desc:物料描述(产品名称)
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string matdesc { get; set; }

        /// <summary>
        /// Desc:派工数量(生产数量)
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string quantity { get; set; }

        /// <summary>
        /// Desc:派工工序
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string disque { get; set; }

        /// <summary>
        /// Desc:派工工序描述
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string disque_desc { get; set; }

        /// <summary>
        /// Desc:销售订单号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string sdno { get; set; }

        /// <summary>
        /// Desc:客户名称
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string cusname { get; set; }

        /// <summary>
        /// Desc:客户信息
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string cusmsg { get; set; }

        /// <summary>
        /// Desc:计划员工号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string planerid { get; set; }

        /// <summary>
        /// Desc:计划员姓名
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string planername { get; set; }

        /// <summary>
        /// Desc:计划开始时间
        /// Default:
        /// Nullable:True
        /// </summary>           
        public DateTime? begintime { get; set; }

        /// <summary>
        /// Desc:计划结束时间
        /// Default:
        /// Nullable:True
        /// </summary>           
        public DateTime? endtime { get; set; }

        /// <summary>
        /// Desc:生产订单号
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string poid { get; set; }

        /// <summary>
        /// Desc:
        /// Default:CURRENT_TIMESTAMP
        /// Nullable:True
        /// </summary>           
        public DateTime? createtime_dt { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string createuser_str { get; set; }

        /// <summary>
        /// Desc:
        /// Default:CURRENT_TIMESTAMP
        /// Nullable:True
        /// </summary>           
        public DateTime? modifytime_dt { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public string remark_str { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public bool? isenable_bit { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public bool? isactive_bit { get; set; }

        /// <summary>
        /// Desc:
        /// Default:
        /// Nullable:True
        /// </summary>           
        public bool? issync_bit { get; set; }

        

        /// <summary>
        /// Desc:
        /// Default:0
        /// Nullable:True
        /// </summary>           
        public int? state_int { get; set; }

        public string state_desc { get; set; }


        public string workseq { get; set; }

        public string workseqdesc { get; set; }



        public string workseqgroup { get; set; }

        public string workseqgroupdesc { get; set; }

        public string operatorcode { get; set; }


        public string productid { get; set; }

        public string repaircode { get; set; }


        public int torquetimes { get; set; }

        public int curtimes { get; set; }

        public string userid { get; set; }

        public string equipmentid { get; set; }
        public string processtype { get; set; }

    }
}
